Element functions
Element function is:
· Function that is always applied to a single item (element) within set.
List of functions that are supported in designer:
|
CubePlayer Functions |
MDX Functions used to create CubePlayer
Functions |
|
Best
N |
Equivalent
to TopCount |
|
Best in
Sum |
Equivalent
to TopSum |
|
Best in
Percent |
Equivalent
to TopPercent |
|
Worst
N |
Equivalent
to BottomCount |
|
Worst in
Sum |
Equivalent
to BottomSun |
|
Worst in
Percent |
Equivalent
to BottomPercent |
|
Order |
Equivalent
to Order |
|
Order by
Alphabet |
Combination
of Order function and order conditions |
|
Order by
Hierarchy |
Equivalent
to Hierachize |
|
Filter |
Equivalent
to Filter |
|
Remove
member(s) |
Combination
of Filter (and NOT members …) |
|
First
N |
Equivalent
to Head |
|
Last
N |
Equivalent
to Tail |
|
Without
empties |
Equivalent
to NonEmpty |
|
DrillD Down
Level |
Implementations of Generate to select
level |
Whenever element function is applied to the row's or column's element
name of the function will be added to the item
Element
functions
Element functions will always be applied to single element.
Example
We have level
We will apply TopCount 100 on entire axis
SELECT
NON
EMPTY
TopCount
(
{
[Customer].[hCountry].[
}
,100, [Measures].[Store Sales]
)
ON
AXIS(0)
FROM
[Sales]
At this point Axis function, Dimension functions and element functions are the same since they are
applied on only one dimension.
Let us add another element from another dimension/hierarchy
SELECT
NON
EMPTY
CrossJoin
(
{
TopCount
(
{
[Customer].[hCountry].[
}
,100, [Measures].[Store Sales]
)
},
{
[Product].[hProduct].[Product Family].MEMBERS
}
)
ON
AXIS(0)
FROM
[Sales]
At this point Dimension functions and Element functions are the same since they are
only one element from each dimension.
Now we will make difference. We
will add another element from Customer dimension,
SELECT
NON
EMPTY
CrossJoin
(
{
TopCount
(
{
[Customer].[hCountry].[
}
,100, [Measures].[Store Sales]
),
[Customer].[hCountry].[Country].&[
},
{
[Product].[hProduct].[Product Family].MEMBERS
}
)
ON
AXIS(0)
FROM
[Sales]
As you can see Element function remains applied on element from beginning, other words on only
one element.